﻿using System.Linq;
using System.ServiceModel.DomainServices.Hosting;
using System.ServiceModel.DomainServices.EntityFramework;

namespace GlobalOfficeTools.Web.RIA.SystemContext
{
    [EnableClientAccess]
    public class SystemService : DbDomainService<GlobalOfficeToolsContext>
    {
        #region CRUD Methods
        #endregion

        #region Custom Methods
        public IQueryable<SYStblMenu> ListMenus()
        {
            return from x in this.DbContext.SYStblMenus
                   select x;
        }
        public IQueryable<SYSvwUserState> ListUserStates()
        {
            return from x in this.DbContext.SYSvwUserStates
                   orderby x.UserStateId
                   select x;
        }
        #endregion
    }
}